FO_External_Form_Definition
Not required maintenance but is needed for embedding external reports using Microsoft SQL server reporting URL based pointers. (The external URLs made using SSRS reporting function.)
Use table name in SQL statements as FO_External_Form_Definition
|
Field |
Type |
Notes |
|
ExternalForms_ID |
bigint |
ID field, a counter. Unique |
|
ExternalFormCode |
varchar(50) |
Code to identify a single report. Enter a unique string as the code. |
|
Description |
varchar(255) |
Enter a description for the report. |
|
ReportURL |
varchar(800) |
URL that launches the report in the SSRS server. Enter a valid URL. |
|
ReportType |
varchar(50) |
Code for the report type. Enter a string to identify the type. This code may be used as the type for other reports also. |
|
CreateDate |
datetime |
Date record was created. Informational |
|
EditDate |
datetime |
Date record was edited. Informational |
|
CreateUser |
varchar(50) |
User who created the record. Informational |
|
EditUser |
varchar(50) |
User who edited the record. Informational |
|
FPModule |
varchar(50) |
Swaps the default Rhodesformat for the SSRS form defined. Enter a valid FPModule code to enable. Valid FPModule Code: BATCHPROCESS |
|
PermGroups |
varchar(1000) |
Determines which users can see a report based on permission group codes. Leave blank to make report available to all users. Multidimensional pipe delimited valueMethod which allows entry of multiple values in a field. Values are separated by the pipe character -- | In addition a leading, or starting, and trailing, or ending pipe is required. For example the string |A|B|C|D| provides the values A, B, C and D to the system., with leading and trailing pipes. Enter valid permission group codes separated by pipes. |